package com.example.course.mapper;

import com.example.course.bean.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface StudentMapper {
    Student selectStudent(Student student);
    List<Student> selectStudents();
    int updateStudent(Student student);
    int deleteStudent(int  id);
    int insertStudent(Student student);
    List<Student> selectStudentById(@Param("teacherId") int teacherId,@Param("courseId") int courseId);
    int insertCourseByStudent(@Param("courseId") int courseId,@Param("studentId") int student,@Param("teacherId") int teacherId);
    int deleteCourseByStudent(@Param("studentId") int student,@Param("courseId") int courseId);
    Student selectStudentStudentById(int id);;
    Student selectStudentByAccount(String account);
    List<Student> selectStudentByTeacherId(@Param("teacherId") int teacherId);
    int deleteCourseStudent2(int id);
    List<Object> selectStudentByStudentId(int id);
}
